<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filtering on metric-to-metric comparisons</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
img_whs2 { border:none; width:17px; height:17px; float:none; border-style:none; }
img_whs3 { border:none; width:17px; height:17px; float:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nFiltering on metric-to-metric comparisons");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filtering on metric-to-metric comparisons</h1>
<p>You can compare values of two metrics to filter the results of a report 
 by creating metric-to-metric qualifications. This type of metric qualification 
 can provide analysis such as comparing metric values over time.</p>
<p>The steps below show you how to create a view filter with a metric-to-metric 
 qualification, as well as how the example scenario above was created. 
 </p>
<h2>Prerequisite</h2>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You need 
 the Web Use View Filter Editor privilege. This privilege is part of OLAP 
 Services.</p></li>
</ul>
<h2>To create a view filter with a metric-to-metric qualification</h2>
<ol start="1" type="1" class="whs1">
	
<li class=p><p>Log into a project in MicroStrategy Web.</p></li>
	
<li class=p><p>Run the report in Grid View. </p></li>
	
<li class=p><p>If the View Filter area is not displayed, from the<span 
 style="font-weight: bold;"><B> Tools</B></span> menu, select <span style="font-weight: bold;"><B>View 
 Filter</B></span>. </p></li>
	
<li class=p><p>In Web, in the <span style="font-weight: bold;"><B>View 
 Filter</B></span> area, click <span style="font-weight: bold;"><B>Add Condition</B></span>. 
 </p></li>
	
<li class=p><p>&nbsp;From the <span style="font-weight: bold;"><B>Filter 
 On</B></span> drop-down list, select a metric.</p></li>
	
<li class=P><p>Select an operator from the drop-down list and type 
 a value. </p></li>
	
<li class=P><p>To compare the metric to another metric, click the <span 
 style="font-weight: bold;"><B>Select</B></span> <span style="font-weight: bold;"><B>Metric</B></span> 
 icon <img src="images/viewfilterattribute.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs2">. Then select 
 another metric to compare it to. </p></li>
	
<li class=P><p>Click <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs3"> to complete the view filter qualification.</p></li>
	
<li class=P><p>If the <span style="font-weight: bold;"><B>Auto-Apply Changes</B></span> 
 check box is cleared, click <span style="font-weight: bold;"><B>Apply</B></span> 
 to apply the view filter to the report. </p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
